# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月21日
"""
import openpyxl


def myFunc(x, y):
	if x.value is None:
		x.value = 0
	if y.value is None:
		y.value = 0
	return x.value + y.value


myBook = openpyxl.load_workbook('员工表.xlsx', data_only=True)
mySheet = myBook.active

myList = list(map(myFunc, list(mySheet.columns)[3][1:],
                  list(mySheet.columns)[4][1:]))

myIndex = 0
for myCell in list(mySheet.columns)[5][1:]:
	myCell.value = myList[myIndex]
	myIndex += 1

myBook.save('结果表-员工表.xlsx')
